/*
 * Copyright (c) 2011 Auzingers
 * Created by Oui-IT
 *
 * Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except
 * in compliance with the License. You may obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software distributed under the License
 * is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express
 * or implied. See the License for the specific language governing permissions and limitations under
 * the License.
 */
package com.auzingers.docsorganizer.db;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * Database helper class for the DocsOrganizer - creates database tables.
 */
public class DocsOrganizerDbHelper extends SQLiteOpenHelper {

    private static final String DATABASE_NAME = "docsorganizer";
    private static final int DATABASE_VERSION = 1;

    /**
     * Default constructor.
     * @param context current context
     */
    public DocsOrganizerDbHelper(Context context) {
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE collection (_id integer primary key autoincrement, resource_id text not null, "
                + "title text not null);");
        db.execSQL("CREATE INDEX idx_collection_resource_id ON collection (resource_id);");
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        //there's no db upgrade right now

        //Log.w(TAG, "Upgrading database from version " + oldVersion
        //        + " to "
        //        + newVersion + ", which will destroy all old data");
        //db.execSQL("DROP TABLE IF EXISTS titles");
        //onCreate(db);
    }

}
